UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7b1QqqREh147sqKGiuSRHOFN6LbEcuAw4IFBu6mc/Ro='
WHERE
key_id = 'f6c440a2bb648e59e3852c1026f0d763b88a8d1ffd5f74dfa1b7428c4ab1af4b'
AND (
token = '7b1QqqREh147sqKGiuSRHOFN6LbEcuAw4IFBu6mc/Ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)