UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzmE8g0sSL0+MCoWlKeNnU9bpU8mR2ZPN+RQWoLdI5A='
WHERE
key_id = 'c9d6769a1386409ae46c835bc082ec3517a84f9efa661c503ac0297efefcc270'
AND (
token = 'pzmE8g0sSL0+MCoWlKeNnU9bpU8mR2ZPN+RQWoLdI5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)