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