UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2fU+XyNaTxcR7VRwMBdiLAd8r7IJbMt6dBtZn8AgKhE=' 
WHERE 
  key_id = '859d04e29b3d6b1e7f4cf599b16410ed7b3b71e5d0c2ddb557315bc761cf5887' 
  AND (
    token = '2fU+XyNaTxcR7VRwMBdiLAd8r7IJbMt6dBtZn8AgKhE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030