UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E634c1nwyg/F+qNbguBtoyP/2re4LifsMmgNF9ZMGdE='
WHERE
key_id = 'f7e0dc3494be3572eb7b27357ddd092f7bc296d087344bb5820184a8c85b77a2'
AND (
token = 'E634c1nwyg/F+qNbguBtoyP/2re4LifsMmgNF9ZMGdE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)