UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z4yKnw5rvBXXrJj6QEwGPTaT83obW3HUkaicJF3UyKs='
WHERE
key_id = '6997c27ef5c5fa1f509b1464d6801771a5875df78176517a4c495c70ec932c77'
AND (
token = 'Z4yKnw5rvBXXrJj6QEwGPTaT83obW3HUkaicJF3UyKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)