UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9LkiibJCYAgrAuRXs1olbjei7tSx67etFb3jKDTJGnE='
WHERE
key_id = 'ff21b3aa7834023bd38d606e8823766e602449439433d81b8fa0bf2d9d16cb6e'
AND (
token = '9LkiibJCYAgrAuRXs1olbjei7tSx67etFb3jKDTJGnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)