UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vBYxJpXfSMOl7VxiIOxcKJ8z4a0t7eiGxUGk99ymUWU='
WHERE
key_id = '28de1f2e5513d58574422f9615cca9a719e79da788f4c8dde6b22fddff74791b'
AND (
token = 'vBYxJpXfSMOl7VxiIOxcKJ8z4a0t7eiGxUGk99ymUWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)