UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PsF7KVSqMOUEui+kdgmqlIfNjyQT4EZsCgM0RMRmOEY='
WHERE
key_id = '8706bba31371acfe45c537d7e8812d27cc53e14b7f8e6ff9c0251661351540c1'
AND (
token = 'PsF7KVSqMOUEui+kdgmqlIfNjyQT4EZsCgM0RMRmOEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)