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