UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wt1IzHsrp1DUzbVIzyk1ZrSnHnPgTXiJFaPqi6nv66U='
WHERE
key_id = '875b08f3c79644e4b0744274b991832ebfcb179f2ca31a8a986554402b57a8c0'
AND (
token = 'Wt1IzHsrp1DUzbVIzyk1ZrSnHnPgTXiJFaPqi6nv66U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)