UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RZ7jZSiLhrOKewrKvqcBziXumpvEq/HU5ieWtdG6eMM='
WHERE
key_id = 'daa8f27549acc654e44b70cb7fb45cabad605077ec2a92d6ca752ce04ed6284e'
AND (
token = 'RZ7jZSiLhrOKewrKvqcBziXumpvEq/HU5ieWtdG6eMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)