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