UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWVFvcICYqwyKQ+1G93YawTmqoinQlc+G7hk/INic1I='
WHERE
key_id = 'ae466e549ea7ce5af12fb6f0227876896f289ea0522d1496c22d0629bff7d90a'
AND (
token = 'ZWVFvcICYqwyKQ+1G93YawTmqoinQlc+G7hk/INic1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)