UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIavwkMEaHc9by+NW6zwjL/XlTWfwlvSHF6ztXFKeq8='
WHERE
key_id = 'dffdce1405bcd5e74e4b96fdde5c29e2531b84c939be5a7f4e18b5c2757abaf7'
AND (
token = 'ZIavwkMEaHc9by+NW6zwjL/XlTWfwlvSHF6ztXFKeq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)