UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yJ0p3pVOR70P4gQaOGoYWjrd2QvFN6+PwgVoi836sWo='
WHERE
key_id = '1e9c201de5ac1fd5ff04fae904dcd71198c7beb777bf06d98cac6662a911d211'
AND (
token = 'yJ0p3pVOR70P4gQaOGoYWjrd2QvFN6+PwgVoi836sWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)