UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y4fneWHbrQvDtM1znaAiBwqE77zwZpWwclHqobczxf4='
WHERE
key_id = '520ed57d9eb2a6b1fb294aa6f819f3aae509c615b3b504ec165127c6732c39a9'
AND (
token = 'Y4fneWHbrQvDtM1znaAiBwqE77zwZpWwclHqobczxf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)