UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xXV9Dbw0RCGrDW+pKi2RR+QG+WrNZJAGS1LoW4ui2P4='
WHERE
key_id = 'b56df9846891325ab3429b496c60c1a12b1d10a218c5a5866d55a5028b9e78df'
AND (
token = 'xXV9Dbw0RCGrDW+pKi2RR+QG+WrNZJAGS1LoW4ui2P4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)