UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E2aCjz0JlVqcqRpL7J+AKoykZC3vMx82khqVRcDoorQ='
WHERE
key_id = 'aa911f9dd33c02df443420b10a2b9ac06e16dbd2654add025627bdd6a2efdc37'
AND (
token = 'E2aCjz0JlVqcqRpL7J+AKoykZC3vMx82khqVRcDoorQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)