UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'riwgXoccJnVk5Tn4NX5vsfIIiCm+tT4x3GEG47Pi5FA='
WHERE
key_id = 'd396bc9b80377a30272a162df2ce8e145ea214154f256a0928a213cd85951916'
AND (
token = 'riwgXoccJnVk5Tn4NX5vsfIIiCm+tT4x3GEG47Pi5FA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)