UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QnkFcSgeaXnb/oe1atk+S26fs9l35mMygPPv2hwnA4U=' 
WHERE 
  key_id = '22eeeef80d2c32f298a4f7b3e6e9b57ec435eae6a998b198a41deeb33fb52a90' 
  AND (
    token = 'QnkFcSgeaXnb/oe1atk+S26fs9l35mMygPPv2hwnA4U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046