UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7pgYFRtjD6l9SQlhoE2HBWv4lqlzp3oEZcvFGYDAHkE='
WHERE
key_id = '3ae81ae56a210aee8612281f3b4c3c09744bedf7f9ec3b74533b4a30ea7966e7'
AND (
token = '7pgYFRtjD6l9SQlhoE2HBWv4lqlzp3oEZcvFGYDAHkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)