UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXW87ry0PChetBjRY+dYF2AtlV8yYBCwewJ5uFRHLtU='
WHERE
key_id = '3becdcc9c50b16adcbcbfcb1e9c1ab5de8acb4bd78f46a92c2e0d237f17dba1c'
AND (
token = 'cXW87ry0PChetBjRY+dYF2AtlV8yYBCwewJ5uFRHLtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)