UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k+EUvIQfZZCvYgVRXIfd3tP4v/dEwISYvuTX/6O0VPY='
WHERE
key_id = 'ca1d5ed3f7852d9a03f2306ef8e76fcce37be425620953d4a29149f6468f4877'
AND (
token = 'k+EUvIQfZZCvYgVRXIfd3tP4v/dEwISYvuTX/6O0VPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)