UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6WZIhn8dlOlhEH1O79xe9SNIbOzW19LZamVGokkErVM='
WHERE
key_id = '7860e9757a179379e9f50a7afbcb0dee58eb7ce6a16edb47ac4ba63138a5800b'
AND (
token = '6WZIhn8dlOlhEH1O79xe9SNIbOzW19LZamVGokkErVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)