UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxpJMvCo9A1oZPkvyRLmSCgMJS5bB6yLTcoYQKNGV+g='
WHERE
key_id = '0658074c13a458a2ca79ca4b4067195f2a00672b3c8f6bbd549c5b68f195ce84'
AND (
token = 'sxpJMvCo9A1oZPkvyRLmSCgMJS5bB6yLTcoYQKNGV+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)