UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HhVJ2RzNSU4UKXZ889NhYAaRApMe0S2wcDwoCLRHWZo='
WHERE
key_id = 'd47f2c3cdee7d3a138b465d3bb2b8c1b5b90b4e0a06397e73b6d6f36b889a43e'
AND (
token = 'HhVJ2RzNSU4UKXZ889NhYAaRApMe0S2wcDwoCLRHWZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)