UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOZi/ux771kSTijEX400hufoh+CYxA6JzUl+yvAeTCw='
WHERE
key_id = '0216f41a91592ab3bd575167950232a46d22acc05871ec924eb20a8a5312f897'
AND (
token = 'HOZi/ux771kSTijEX400hufoh+CYxA6JzUl+yvAeTCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)