UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1qEYFJ6yzjuxjihHgnVCw1Lc6Ws0U52MAIbcu34uqg='
WHERE
key_id = '2f013c7a4e7a0006dd1748cd281620b4f27d23b9253ecbeab179c1ab74a23f14'
AND (
token = 'z1qEYFJ6yzjuxjihHgnVCw1Lc6Ws0U52MAIbcu34uqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)