UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xPVY4Hk8tLPqWZmitK0RI31pCPdfUhq2UY7qj4hFa0='
WHERE
key_id = '20478b02bf78c9169dd1475178dec653a8f8092a77ba251ddf08613b9298a08a'
AND (
token = '8xPVY4Hk8tLPqWZmitK0RI31pCPdfUhq2UY7qj4hFa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)