UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CONk6VQthcAjz9Fm9JQK3FwWXp9JbAAeERPwp9KUbNs='
WHERE
key_id = 'cdac887b953b1327483123af6f230d949e976da2e83170bb811be39fc9b50f22'
AND (
token = 'CONk6VQthcAjz9Fm9JQK3FwWXp9JbAAeERPwp9KUbNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)