UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rqJ7aukTuL8SfwGRjBAUNPNK4/wTwTKwqm/aGiw63GY='
WHERE
key_id = '57d1ea9e51271662a94e63a9b2d4f8868bb94ae41e4ea166e43b8baa6d3b0be3'
AND (
token = 'rqJ7aukTuL8SfwGRjBAUNPNK4/wTwTKwqm/aGiw63GY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)