UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XrnzX6iu5rHMDF8rKBPu0N77kZ4wNoefhSlu65aBBC8='
WHERE
key_id = '612bc7349b96ba32486982dd92bd17bae2d4080c1c447690e4a344a2f9a7b65d'
AND (
token = 'XrnzX6iu5rHMDF8rKBPu0N77kZ4wNoefhSlu65aBBC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)