UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vFOOLj54CpvZrgbhBeS+uOdDLHI7sgoT8vf8NezdRcc='
WHERE
key_id = 'c4b877c4ef68bdfbc116fc550182d1889120213066a284f93b6c2873e8d0735e'
AND (
token = 'vFOOLj54CpvZrgbhBeS+uOdDLHI7sgoT8vf8NezdRcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)