UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SWjZ9aBLIwEO+/TVT8SQuThDwkl/VPW2hW/xxHCrmKA='
WHERE
key_id = 'adf0b649347a0e51fddc76c9807cefd03de48165335e2e94f86d4ad3fa399ea4'
AND (
token = 'SWjZ9aBLIwEO+/TVT8SQuThDwkl/VPW2hW/xxHCrmKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)