UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6VMawzYLKlDFiNpXmw4wATycXFVg+6upFc3MMWVEwIk='
WHERE
key_id = 'e19e52c908a2e0e91f78441f8f52627bb6faef6be5e3512de365e5235aba48a4'
AND (
token = '6VMawzYLKlDFiNpXmw4wATycXFVg+6upFc3MMWVEwIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)