UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dI6fyHcLSUsgMYYxBcCA++IQX9qWrHpA7Oo5nCcOOio='
WHERE
key_id = 'c97cecff608b84ae692d627768b538eb0f635a8f004babad3910b48749744d49'
AND (
token = 'dI6fyHcLSUsgMYYxBcCA++IQX9qWrHpA7Oo5nCcOOio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)