UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUQN1uTWNjeApiPGzxrfIeCgsN+L0Whr4qcYwOyl0Hg='
WHERE
key_id = '7b0712acfa58fa8e86ee53745b3f3a673f03cd167dc3555b1a7a990f1b543e46'
AND (
token = 'ZUQN1uTWNjeApiPGzxrfIeCgsN+L0Whr4qcYwOyl0Hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)